<%@ page import="java.util.List" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.DriverManager" %><%--
  Created by IntelliJ IDEA.
  User: lenovo
  Date: 2018/4/3
  Time: 15:56
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>用户列表</title>
</head>
<body>

<%--这里不能用你前方法进行登录判断，需要单独写一个isLogin页面来判断登录状态，在其他页面用include引入
。否则这里面的session和其他页面的session不是同一个session，这样它判断是否为空时始终都会为空，会进入死循环
--%>
<%@include file="isLogin.jsp" %>
<%--<%
    //判断用户是否登录
    if( session.getAttribute("isLogin")== null);
    //没有登陆就跳转到login.jsp
    response.sendRedirect("login.jsp");
%>--%>
 <style type="text/css">
     table{
         border: 1px solid #000;
         padding: 10px;
         border-collapse: collapse;
     }
     td, th {
         border: 1px solid #000;
         padding: 10px;
         border-collapse: collapse;
     }

 </style>
 <a href="addUser.jsp">增加用户</a>
<table>
    <tr>
        <td>编号</td>
        <td>用户名</td>
        <td>密码</td>
        <td>操作1</td>
        <td>操作2</td>
    </tr>
   <%
       class User{
           int id;
           String username;
           String password;
       public User(int id,String username,String password){
           this.id = id;
           this.username = username;
           this.password = password;
       }
       }


       List<User> userList = new ArrayList<User>();
       //从数据库读取数据，并放在userList中
       //3+1
       Connection connection = null;
       Statement statement = null;
       ResultSet resultSet = null;

       String sql = "select * from t_users";

       Class.forName("com.mysql.jdbc.Driver");

       connection = DriverManager.getConnection(
               "jdbc:mysql://localhost:3306/sctu_javaweb_2018?serverTimezone=UTC",
               "root",
               "113223"
       );
      /*
       User chen = new User();
       chen.id = 1;
       chen.username ="chenggongsuo";
       chen.password = "123";
       userList.add(chen);

       User qin = new User();
       qin.id = 2;
       qin.username ="qinqin";
       qin.password = "456";
       userList.add(qin);
      */
      statement = connection.createStatement();
      resultSet = statement.executeQuery(sql);
      //resultSet-》List
       while(resultSet.next()){

           int id = resultSet.getInt(1);
           String username = resultSet.getString(2);
           String password = resultSet.getString(3);
           User user =new User(id,username,password);
           userList.add(user);

       }
       resultSet.close();
       statement.close();
       connection.close();
       //封装起来 面对对象的三个特征：封装，继承，多态


       for(User user:userList){
           //221
           out.write("<tr><td>"+user.id+"</td><td>"+user.username+"</td><td>"+user.password+"</td>" +
                   "<td><a href='userUpdata.jsp?id="+user.id+ "&name="+user.username+"&psd="+user.password+
                   "'>更新</a></td><td><a href ='userDelete.jsp?id="+user.id+"'>删除</a></td></tr>");
       }


   %>

</table>

</body>
<%@include file = "footer.jsp"%>
</html>
